Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#135338 - 15/01/2003 13:42 ID3 tags > SQL?
seang
new poster

Registered: 14/05/2000
Posts: 28
This isn't exactly Empeg related but I was hoping that the community might be able to help nonetheless...

I've been searching for a program that would let me catalog my MP3s to a SQL database but so far, I haven't been able to find one. I need the Title, Artist, Album, Genre, Track # and the complete path of where the file resides as fields plus some empty fields for times played, playlist membership and whatnot. Emplode's export to CSV works quite well but is missing the path information to where the file originally resides on my NT server which is understandable. Anyone know of such a program?

Also, has anyone tried coding a shoutcast output applet for the Empeg?
_________________________
Sean BMW [blue]/[/blue][purple]/[/purple][red]/[/red]M3 - 30 Gig [red]RED[/red] Mk2a RioCar

Top
#135339 - 15/01/2003 13:47 Re: ID3 tags > SQL? [Re: seang]
Biscuitsjam
enthusiast

Registered: 22/01/2002
Posts: 355
I wrote a similar program a while back (not Empeg related). I've been considering doing the same thing here. I'm pretty sure it could be done in less than a day by anyone semi-skilled.

-Biscuits

Top
#135340 - 15/01/2003 13:52 Re: ID3 tags > SQL? [Re: seang]
Daria
carpal tunnel

Registered: 24/01/2002
Posts: 3937
Loc: Providence, RI
I could give you some perl to do it, but it's ugly.

Top
#135341 - 15/01/2003 14:28 Re: ID3 tags > SQL? [Re: seang]
jimhogan
carpal tunnel

Registered: 06/10/1999
Posts: 2591
Loc: Seattle, WA, U.S.A.
Mike Oliphant's DDJ (Digital DJ) does most of this in concert with Grip and MySQL. This of course assumes you are running Linux. (edit:: I don't think it is as expandable as you'd like, but there's a new verion out -- haven't used it -- so thought it might be worth a look. When I used it, I used it with PHPMyAdmin to clean up entries, and I expect you could use that to add all the new fields you want.)


Edited by jimhogan (15/01/2003 14:32)
_________________________
Jim


'Tis the exceptional fellow who lies awake at night thinking of his successes.

Top
#135342 - 15/01/2003 14:36 Re: ID3 tags > SQL? [Re: seang]
Tim
veteran

Registered: 25/04/2000
Posts: 1522
Loc: Arizona
mp3sql will do it, if perl doesn't scare you. There was also another script I used like 4 years ago to do the same thing (also Perl based), but that was a lot of lost brain cells ago and can't remember the name of it.

Top
#135343 - 15/01/2003 14:57 Re: ID3 tags > SQL? [Re: Tim]
Daria
carpal tunnel

Registered: 24/01/2002
Posts: 3937
Loc: Providence, RI
mp3sql had (some problem) which caused me to not use it. I wish I remembered what it was.

Top